Learning Objectives

After completing this lesson, you’ll be able to:

Resources

Introduction

As a resident FME expert, you are often asked to translate data (particularly the community map) between formats. You realize that it would be much simpler if you created a workspace to do this - regardless of format - and let the end-users carry out the translation themselves. You've started to build a workspace, but now you need to add fanouts to make sure the users receive data in the form they expect.

Note

In the future, this would make an excellent use for an FME Server Data Download service, but for now, we'll let the users simply run the workspace in FME Workbench. To learn more about creating self-serve data download workflows, see the FME Server Authoring learning path.

1) Start Workbench

Open the starting workspace in FME Workbench 2021.1 or later.

2) Explore the Workspace

You can see from the Navigator that this workspace reads in a community map file Geodatabase and writes out to the Generic format:

Reader and writer formats in the Navigator

The workspace provides four format choices to the user, controlled by User Parameters > OutputFormat.

Note

The Generic format lets the user choose which format to write. You can learn more in the Documentation.

The reader feature type is merged, meaning that it will read all features into one stream, rather than individual feature types per feature class. You can tell the feature type is configured that way because it is named <All>. Right now the writer feature type is set to write to a single feature type named NewFeatureType.

Feature type names

Examining the User Parameters shows that the workspace is configured to let the user choose which feature types to read. The user configured it this way by linking the FEATURE_TYPES parameter to the Reader Parameters > Features To Read > Feature Types to Read parameter.

If the workspace is run now, the user will be able to choose the feature types and format but will get the results back in a single layer/file. This result is obviously not optimal. Let's change the workspace so the user gets back separate layers/files for each feature type. We'll also zip the output for convenience.

3) Set Feature Type Fanout

We would like to output features to their original table. To do this we need to know where they came from, and that is obtained from a format attribute called fme_feature_type.

Inspect the properties for the writer feature type. Set a fanout by choosing fme_feature_type as the attribute supplying the feature type name.

Setting Feature Type Name to fme_feature_type

Your dialog should look like this:

Feature type fanout

Click OK. The name of the feature type will change to <@Value(fme_feature_type)> to reflect the use of a fanout.

4) Create a Zipped Output

In the Navigator, find the Destination Generic (Any Format) Folder writer parameter:

 Destination Generic (Any Format) Folder parameter in the Navigator

We will create a zipped folder to contain all of our files. Double click the parameter and set the location of an output folder (such as C:\FMEData\Output\Training) then at the end type \CommunityMapping.zip.

Your full parameter value will look something like this:

C:\FMEData\Output\Training\CommunityMapping.zip

This will create a zipped file called CommunityMapping.

5) Save and Run Workspace

Save the workspace and then run it with the prompt option set. When prompted, select some source tables to read (include at least the GarbageSchedule plus one other). Set Esri Shapefile as the format to write. Ensure your path reflects that you will be writing a zipped file:

Checking the output path Click the Run button to run the translation. Examine the output folder. A zipped folder has been created which contains all the selected tables that have been written back to Shapefile format:

Community Mapping zip output

Now you have a solution that almost anyone will be able to open and run for themselves. Also, if you published the workspace to FME Server it would automatically create a web page that matched the different user parameters.

Note

Did you notice that FME handled the different geometry types and output the files with the geometry as part of the name? It’s a Shapefile format thing. FME can never – and will never – write more than one geometry type to the same Shapefile .shp file.

The one drawback with the output is that each Shapefile has all of the attributes of all of the source tables. To avoid that you would need to use a dynamic translation. You can read about dynamic translations in the Documentation or follow this tutorial.